In de Zend Framework Manual wordt een SQLite Db resource gebruikt, we willen echter een MySQL Db resource.
Zend Framework Command Line Tool
zf configure db-adapter \
> 'adapter=PDO_MYSQL&dbname="quickstart"&host="localhost"&username="root"&password=""' \
> production
A db configuration for the production section has been written to the application config file.
zf configure db-adapter \
> 'adapter=PDO_MYSQL&dbname="quickstart"' \
> testing
db configuration for the testing section has been written to the application config file.
zf configure db-adapter \
> 'adapter=PDO_MYSQL&dbname="quickstart"' \
> development
A db configuration for the development section has been written to the application config file.
Resultaat
; application/configs/application.ini
[production]
; ...
resources.db.adapter = "PDO_MYSQL"
resources.db.params.dbname = "quickstart"
resources.db.params.host = "localhost"
resources.db.params.username = "root"
resources.db.params.password = ""
[testing : production]
; ...
resources.db.adapter = "PDO_MYSQL"
resources.db.params.dbname = "quickstart"
[development : production]
; ...
resources.db.adapter = "PDO_MYSQL"
resources.db.params.dbname = "quickstart"